create external table jms_dm.dm_network_arrival_union_deliver_sum_dt
(
agent_code      string COMMENT '代理区code' ,
agent_name      string COMMENT '代理区名字' ,
provider_id     string COMMENT '省份id' ,
provider_desc   string COMMENT '省份' ,
city_id         string COMMENT '城市id' ,
city_desc       string COMMENT '城市' ,
scan_site_code  string COMMENT '网点code' ,
name            string COMMENT '网点名字' ,
ordersource_name   string COMMENT '订单来源' ,
waybill_num          bigint COMMENT '运单总量' ,
arrival_deliver_num  bigint COMMENT '到出一体总量' ,
after_deliver_num    bigint COMMENT '稍后出仓总量' ,
date_time string COMMENT '业务日期' )
comment '网点到出一体监控'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_network_arrival_union_deliver_sum_dt'
TBLPROPERTIES (
        'discover.partitions' = 'false',
         'parquet.column.index.access' = 'true'
         );
